<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="Northwind" assembly="NHibernate.Class">
    <class name="Northwind.Product, NHibernate.Class" table="[dbo].[Products]" lazy="true">
        <id name="ProductID" type="Int32">
            <column name="ProductID" not-null="false" unique="true" />
            <generator class="native" />
        </id>
        <property name="ProductName" type="String">
            <column name="ProductName" length="40" not-null="true" />
        </property>
        <property name="QuantityPerUnit" type="String">
            <column name="QuantityPerUnit" length="20" not-null="false" />
        </property>
        <property name="UnitPrice" type="Decimal">
            <column name="UnitPrice" not-null="false" />
        </property>
        <property name="UnitsInStock" type="Int16">
            <column name="UnitsInStock" not-null="false" />
        </property>
        <property name="UnitsOnOrder" type="Int16">
            <column name="UnitsOnOrder" not-null="false" />
        </property>
        <property name="ReorderLevel" type="Int16">
            <column name="ReorderLevel" not-null="false" />
        </property>
        <property name="Discontinued" type="Boolean">
            <column name="Discontinued" not-null="true" />
        </property>
        <many-to-one name="Category" column="CategoryID" class="Category" not-null="true" />
        <many-to-one name="Supplier" column="SupplierID" class="Supplier" not-null="true" />
    </class>
</hibernate-mapping>

